2014-02-21 - 11504 - Spec - Cycle count grouping #CrystalReportsSupport

SPECIFICATIONS

11504 - Cycle count grouping

Requirement Summary

Need to update dynamic grouping that had to be incorporated in the crystal report which performs the monthly cycle count.

Admin Info

Purpose	Need to update dynamic grouping had to be incorporated in the crystal report which performs the monthly cycle count.
Requested By	John Fridmann
Spec Created By	Praveen Guntuka
Spec Created Date	02/21/2014
Spec QA by	Uday Kumar P
Objects	CYC100
Document Status	Complete

References

Prior Tickets

None

Documents

None

Functional Requirement

1. Need to create Dynamic Grouping for CYC100 - Cycle Count report.
2. Need to show Dynamic Group name based their Parameter value.

Solution Summary

1. Need to create a Parameter in the report.
2. Need to show the dynamic Grouping based on Parameter value.
3. Need to show the Group name based on parameter value.

Test Plan

SNo.	Test Scenario	Expected Results
1	Execute the new Crystal Report in Crystal Designer tool after changes.	Report should execute successfully in Crystal Designer tool.
2	Schedule the Crystal Report in NEC Infoview.	Report should execute successfully in NEC Infoview.
3	Validate the report with NEC Enterprise production report.	Report should successfully validate with NEC Enterprise production report.

Solution Details

1. Need to create Grouping Order parameter in the report.
2. Need to include Date > Plant and Plant > Date LOVs in the Parameter.
3. Need to create 2 formulas for Dynamic Grouping.
4. Need to change the formula values based on Parameter value.
5. Need to incorporate the logic: Parameter value is Plant > Date then need to show Plant > Date > Click here for detailed view and the Grouping order should be Plant > Planned date for inventory count > Date. But if the
parameter value is Date > Plant then need to show Date > Plant > Click here for detailed view and the Grouping order should be Date > Planned date for inventory count > Plant.

Issues

None